﻿CREATE TABLE [dbo].[AW_RentTransaction] (
    [TransactionId]           UNIQUEIDENTIFIER NOT NULL,
    [PropertyId]              UNIQUEIDENTIFIER NOT NULL,
    [InvoiceNumber]           NVARCHAR (50)    NULL,
    [OpenFileRef]             NVARCHAR (MAX)   NULL,
    [CloseFileRef]            NVARCHAR (MAX)   NULL,
    [ListerId]                UNIQUEIDENTIFIER NULL,
    [ListDate]                DATETIME         NULL,
    [LandlordType]            TINYINT          NULL,
    [LandlordName1]           NVARCHAR (250)   NULL,
    [LandlordName2]           NVARCHAR (250)   NULL,
    [LandlordName3]           NVARCHAR (250)   NULL,
    [LandlordCompany]         NVARCHAR (250)   NULL,
    [LandlordNRIC1]           NVARCHAR (20)    NULL,
    [LandlordNRIC2]           NVARCHAR (20)    NULL,
    [LandlordNRIC3]           NVARCHAR (20)    NULL,
    [LandlordCompanyNo]       NVARCHAR (50)    NULL,
    [LandlordContactPerson]   NVARCHAR (250)   NULL,
    [LandlordAddress]         NVARCHAR (250)   NULL,
    [LandlordPhone]           NVARCHAR (250)   NULL,
    [LandlordMobile]          NVARCHAR (50)    NULL,
    [LandlordFax]             NVARCHAR (250)   NULL,
    [LandlordEmail]           NVARCHAR (250)   NULL,
    [LandLordViewMeetTele]    NVARCHAR (MAX)   NULL,
    [LandlordIncomeTax]       NVARCHAR (50)    NULL,
    [LandlordReferral]        TINYINT          NULL,
    [LandlordReferralName]    NVARCHAR (250)   NULL,
    [LandlordReferralNRIC]    NVARCHAR (20)    NULL,
    [LandlordReferralContact] NVARCHAR (250)   NULL,
    [LandlordReferralStatus]  TINYINT          NULL,
    [LandlordReferralAmount]  DECIMAL (18, 2)  NULL,
    [LandlordReferralAmtSum]  DECIMAL (18, 2)  NULL,
    [AgencyFee]               DECIMAL (18, 2)  NULL,
    [GST]                     DECIMAL (18, 2)  NULL,
    [GSTPaidBy]               TINYINT          NULL,
    [ListingFee]              DECIMAL (18, 2)  NULL,
    [LandlordTAFee]           DECIMAL (18, 2)  NULL,
    [TenantType]              TINYINT          NULL,
    [TenantName1]             NVARCHAR (250)   NULL,
    [TenantName2]             NVARCHAR (250)   NULL,
    [TenantName3]             NVARCHAR (250)   NULL,
    [TenantCompany]           NVARCHAR (250)   NULL,
    [TenantNRIC1]             NVARCHAR (250)   NULL,
    [TenantNRIC2]             NVARCHAR (250)   NULL,
    [TenantNRIC3]             NVARCHAR (250)   NULL,
    [TenantCompanyNo]         NVARCHAR (50)    NULL,
    [TenantContactPerson]     NVARCHAR (250)   NULL,
    [TenantAddress]           NVARCHAR (250)   NULL,
    [TenantPhone]             NVARCHAR (250)   NULL,
    [TenantMobile]            NVARCHAR (50)    NULL,
    [TenantFax]               NVARCHAR (250)   NULL,
    [TenantEmail]             NVARCHAR (250)   NULL,
    [TenantViewMeetTele]      NVARCHAR (MAX)   NULL,
    [TenantIncomeTax]         NVARCHAR (50)    NULL,
    [TenantReferral]          TINYINT          NULL,
    [TenantReferralName]      NVARCHAR (250)   NULL,
    [TenantReferralNRIC]      NVARCHAR (20)    NULL,
    [TenantReferralContact]   NVARCHAR (250)   NULL,
    [TenantReferralStatus]    TINYINT          NULL,
    [TenantReferralAmount]    DECIMAL (18, 2)  NULL,
    [TenantReferralAmtSum]    DECIMAL (18, 2)  NULL,
    [DisbursementFee]         DECIMAL (18, 2)  NULL,
    [Deposit]                 DECIMAL (18, 2)  NULL,
    [DepositMonth]            DECIMAL (18, 2)  NULL,
    [Advance]                 DECIMAL (18, 2)  NULL,
    [AdvanceMonth]            DECIMAL (18, 2)  NULL,
    [WaterElectric]           DECIMAL (18, 2)  NULL,
    [Tel]                     DECIMAL (18, 2)  NULL,
    [TenantTAFee]             DECIMAL (18, 2)  NULL,
    [TransactorId]            UNIQUEIDENTIFIER NULL,
    [CoBroke]                 TINYINT          NULL,
    [CoBrokeId]               UNIQUEIDENTIFIER NULL,
    [TransactDate]            DATETIME         NULL,
    [TransactRemark]          NVARCHAR (MAX)   NULL,
    [TransListType]           TINYINT          NULL,
    [MonthlyRental]           DECIMAL (18, 2)  NULL,
    [TenancyDuration]         DECIMAL (18, 2)  NULL,
    [TenancyDurationType]     TINYINT          NULL,
    [Requisition]             NVARCHAR (500)   NULL,
    [TerminationClause]       NVARCHAR (500)   NULL,
    [PremiseUse]              TINYINT          NULL,
    [CreateDate]              DATETIME         NULL,
    [UpdateDate]              DATETIME         NULL,
    [UpdateWho]               UNIQUEIDENTIFIER NULL,
    [Status]                  TINYINT          NULL,
    [Renewed]                 TINYINT          NULL,
    [TotalTA]                 DECIMAL (18, 2)  NULL,
    [TotalAgencyFee]          DECIMAL (18, 2)  NULL,
    [StampDuty]               DECIMAL (18, 2)  NULL,
    [ListerAmt]               DECIMAL (18, 2)  NULL,
    [ReferralAmt]             DECIMAL (18, 2)  NULL,
    [GovAmt]                  DECIMAL (18, 2)  NULL,
    [GrossAmount]             DECIMAL (18, 2)  NULL,
    [SignDate]                DATETIME         NULL,
    [SignRemark]              NVARCHAR (MAX)   NULL,
    [SignComplete]            TINYINT          NULL,
    [SignCompleteBy]          UNIQUEIDENTIFIER NULL,
    [SignCompleteDate]        DATETIME         NULL,
    [CommencementDate]        DATETIME         NULL,
    [RentFreePeriod]          INT              NULL,
    [RentFreePeriodType]      TINYINT          NULL,
    [CollectDate]             DATETIME         NULL,
    [CollectAmt]              DECIMAL (18, 2)  NULL,
    [CollectRemark]           NVARCHAR (MAX)   NULL,
    [CollectComplete]         TINYINT          NULL,
    [CollectCompleteBy]       UNIQUEIDENTIFIER NULL,
    [CollectCompleteDate]     DATETIME         NULL,
    [UndoDate]                DATETIME         NULL,
    [UndoRemark]              NVARCHAR (MAX)   NULL,
    [UndoAmt]                 DECIMAL (18, 2)  NULL,
    [UndoBy]                  UNIQUEIDENTIFIER NULL,
    [UndoAgencyFee]           DECIMAL (18, 2)  NULL,
    [UndoGST]                 DECIMAL (18, 2)  NULL,
    [UndoGSTPaidBy]           TINYINT          NULL,
    [UndoListerAmt]           DECIMAL (18, 2)  NULL,
    CONSTRAINT [PK_AW_RentTransaction] PRIMARY KEY CLUSTERED ([TransactionId] ASC, [PropertyId] ASC)
);




GO



GO



GO



GO



GO



GO



GO



GO



GO



GO



GO



GO



GO



GO



GO



GO



GO



GO


